QCC Data Warehouse

Patrick Wynne

July 11, 2018

What’s the value add of the data warehouse?

  • Effective dating

  • Snapshots

  • Automation

  • User friendly interface

Effective Dating

  • But CUNY First has effective dates?

Confused

Effective Dating

  • Many cunyfirst tables don’t have effective dates

  • Almost no tables in CUNY first have end dates

Effective Dating

  • Many cunyfirst tables don’t have effective dates

  • Almost no tables in CUNY first have end dates

  • The data warehouse daily scans our CUNY First data, finds changes in records, and creates effective dates/end dates

Snapshots

  • Historical static views of CUNY First at specified points in history

  • Census dates, first day of term, current offset

Snapshots

TimeTravel

Automation

robot

Automation

  • IT has this all set up automatically

  • The reporting instance query

  • Extraction from tumbleweed

  • The effective dating

  • The snapshots

User Interface

  • OBIEE web app interface

  • Abstracts away leftover complexity of datawarehouse

  • No SQL required

  • Drag and drop gui